package com.example.onlinemusic.controller;

import com.example.onlinemusic.mapper.LoveMusicMapper;
import com.example.onlinemusic.mapper.MusicMapper;
import com.example.onlinemusic.model.Music;
import com.example.onlinemusic.model.User;
import com.example.onlinemusic.tools.Constant;
import com.example.onlinemusic.tools.ResponseBodyMessage;
import org.apache.ibatis.binding.BindingException;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.File;
import java.io.IOException;
import java.nio.file.Files;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

@RestController
@RequestMapping("/music")
public class MusicController {


    @Autowired
    private MusicMapper musicMapper;

    @Autowired
    private LoveMusicMapper loveMusicMapper;

    @Value("${music.local.path}")
    private  String SAVE_PATH;

    @RequestMapping("/upload")
    public ResponseBodyMessage<Boolean> insertMusic(@RequestParam String singer,
                                                    @RequestParam("filename")MultipartFile file,
                                                    HttpServletRequest request,
                                                    HttpServletResponse resp){

        //检查是否登录
        HttpSession httpSession = request.getSession(false);
        if (httpSession == null || httpSession.getAttribute(Constant.USERINFO_SESSION_KEY )== null){
            System.out.println("没有登录!");
            return new ResponseBodyMessage<>(-1,"请登录后上传",false);
        }

        String fileNameAndType = file.getOriginalFilename();

        String path = SAVE_PATH + fileNameAndType;

        File dest  =  new File(path);

        if(!dest.exists()){
            dest.mkdir();
        }

        try{
            file.transferTo(dest);
            //return new ResponseBodyMessage<>(0,"上传成功",true);
        }catch (IOException e){
            e.printStackTrace();
            return new ResponseBodyMessage<>(-1,"上传失败",false);

        }

        //return new ResponseBodyMessage<>(-1,"上传失败",false);

        //进行数据库的上传
        //1.准备数据 2.调用insert
        int index = fileNameAndType.lastIndexOf(".");
        String title = fileNameAndType.substring(0,index);

        User user = (User)httpSession.getAttribute(Constant.USERINFO_SESSION_KEY);
        int userid = user.getId();

        String url = "/music/get?path=" + title;

        SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");
        String time = sf.format(new Date());

       try{
           int ret = 0;
           ret = musicMapper.insert(title,singer,time,url,userid);
           if(ret == 1){
               resp.sendRedirect("/list.html");

               return new ResponseBodyMessage<>(0,"数据库上传成功!",true);
           }else {
               return new ResponseBodyMessage<>(-1,"数据库上传失败!",false);

           }

       }catch (BindingException | IOException e){
           dest.delete();
           return new ResponseBodyMessage<>(-1,"数据库上传失败!",false);
       }

    }
    @RequestMapping("/get")
    public ResponseEntity<byte[]> get(String path) {

        File file = new File(SAVE_PATH + path);
        byte[] a = null;
        try {
            a = Files.readAllBytes(file.toPath());
            if (a == null) {
                return ResponseEntity.badRequest().build();
            }
            return ResponseEntity.ok(a);
        } catch (IOException e) {
            e.printStackTrace();
        }
        return ResponseEntity.badRequest().build();
    }

    @RequestMapping("/delete")
    public ResponseBodyMessage<Boolean> deleteMusicById(@RequestParam String id){


        int iid = Integer.parseInt(id);

        Music music = musicMapper.findMusicById(iid);
        if (music == null){
            System.out.println("没有这个id的音乐");
            return new ResponseBodyMessage<>(-1,"没有你要删除的音乐",false);
        }else {

            int ret = musicMapper.deleteMusicById(iid);
            if (ret == 1 ){
                int index = music.getUrl().lastIndexOf("=");
                String fileName = music.getUrl().substring(index+1);

                File file = new File(SAVE_PATH + fileName + ".mp3");
                System.out.println("当前的路径:" + file.getPath());

                if (file.delete()){
                    loveMusicMapper.deleteLoveMusicByMusicId(iid);
                    return new ResponseBodyMessage<>(0,"服务器当中的音乐删除成功!",true);
                }else {
                    return new ResponseBodyMessage<>(-1,"服务器当中的音乐删除失败!",false);
                }

            }else{
                return new ResponseBodyMessage<>(-1,"服务器当中的音乐删除失败!",false);
            }
        }

    }


    @RequestMapping("/deleteSel")
    public ResponseBodyMessage<Boolean> deleteSelMusic(@RequestParam("id[]") List<Integer> id) {
        System.out.println("所有的ID ： " + id);
        int sum = 0;
        for (int i = 0; i < id.size(); i++) {
            Music music = musicMapper.findMusicById(id.get(i));
            if (music == null) {
                System.out.println("没有这个id的音乐");
                return new ResponseBodyMessage<>(-1, "没有你要删除的音乐", false);
            }
            int ret = musicMapper.deleteMusicById(id.get(i));
            if (ret == 1) {
                int index = music.getUrl().lastIndexOf("=");
                String fileName = music.getUrl().substring(index + 1);

                File file = new File(SAVE_PATH + fileName + ".mp3");

                if (file.delete()) {
                    loveMusicMapper.deleteLoveMusicByMusicId(id.get(i));
                    sum += ret;
                } else {
                    return new ResponseBodyMessage<>(-1, "服务器当中的音乐删除失败!", false);
                }

            }else {
                return new ResponseBodyMessage<>(-1, "数据库当中的音乐删除失败!", false);
            }
        }
        if (sum == id.size()){
            System.out.println("整体删除成功!");
            return new ResponseBodyMessage<>(0, "服务器当中的音乐删除成功!", true);
        }else {
            System.out.println("整体删除失败!");
            return new ResponseBodyMessage<>(-1, "服务器当中的音乐删除失败!", false);
        }
    }

    @RequestMapping("/findmusic")
    public ResponseBodyMessage<List<Music>> findMusic(@RequestParam(required = false) String musicName){

        List<Music> musicList = null;
        if (musicName != null){
            musicList = musicMapper.findMusicByName(musicName);
        }else {
            musicList = musicMapper.findMusic();
        }

        return new ResponseBodyMessage<>(0, "查询到了所有音乐", musicList);
    }



}
